package edu.must.uh.impl;

import java.sql.SQLException;
import java.util.List;
import java.util.Map;
import edu.must.uh.bean.DeployQueryResultBean;
import edu.must.uh.util.PageHelper;
import edu.must.uh.util.SqlUtils;
import edu.must.uh.util.Tools;
import edu.must.uh.util.ToolsOfString;

public class SharesImpl extends BaseImpl {

    public SharesImpl() {
         super.cashkey     = "shares";
         super.cashListkey = "shares";
         super.keyFields   = "ID";
         super.tableName   = "shares"; 
    }
    
    
    public  List<Map<String,Object>> getlist(Map<String, Object> searchcondition,
            String sqlcondition) throws Exception {        
           
            String sqlString = "SELECT  ITEMNAME,FUNDSNAME,SHAREID,FULLNAME,SORTCODE,CREATETIME FROM v_shares   ";
            List<Map<String,Object>> resList = SqlUtils.getMySqlInstance().getlist(sqlString);
            return resList;
        }
    
    
    
    public List<Map<String,Object>> getSelect() throws SQLException {     
        
        String sqlString = "SELECT  SHAREID,FULLNAME FROM shares where DeleteMark = 0 order by  SortCode;" ;            
        List<Map<String,Object>> resList = SqlUtils.getMySqlInstance().getlist(sqlString);
        return resList; 
    }
    
}
